package com.eiisan.web.mapper;

import java.util.List;

import com.eiisan.web.model.domain.PaymentChannel;
import org.apache.ibatis.annotations.Select;


public interface PaymentChannelMapper {

	@Select("SELECT channel_Name  AS channelName , channel_Id AS channelId, merchant_Id AS merchantId,sync_Url AS syncUrl, asyn_Url AS asynUrl,public_Key AS publicKey, private_Key AS privateKey,channel_State AS channelState ,class_addres as classAddres  FROM payment_channel WHERE CHANNEL_STATE='0';")
    List<PaymentChannel> selectAll();

	@Select("SELECT channel_Name  AS channelName , channel_Id AS channelId, merchant_Id AS merchantId,sync_Url AS syncUrl, asyn_Url AS asynUrl,public_Key AS publicKey, private_Key AS privateKey,channel_State AS channelState ,class_addres as classAddres  FROM payment_channel WHERE CHANNEL_STATE='0'  AND channel_Id=#{channelId} ;")
	PaymentChannel selectBychannelId(String channelId);
}
